<?php

session_start();
if (!isset($_SESSION["role"]))
    header("location:index.php");
?>

<html>
<head>
<meta http-equiv="Content-Type"content="text/html; charset=UTF-8" />
<title>社团信息显示</title>
</head>
<body>
<center>《<?php
include("../functions/db_conn.php");
    $No = $_GET['SociNo'];
    $ShowStudent_sql = "SELECT * FROM soci s,Department d, Mana m WHERE s.DepartNo=d.DepartNo and  s.ManaNo=m.ManaNo and s.SociNo='".$No."'";
    $ShowStudentResult = mysql_query($ShowStudent_sql);
    $row = mysql_fetch_array($ShowStudentResult);
    echo "<b><font color=red>".$row['SociName']."</font></b>";
?>》信息列表<br>点击编号，可查看岗位信息</center>
<table  width="400" border="1" align="center">
    <tr align="center">
        <td width="160">
            <?php
            echo "<img src='../uploadpics/".$row['SociNo'].".jpg' width='160' height='190'>";
            ?>
        </td>
        <td>
            <table width="340" border="1" align="center">
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>编号</b></font></td>
                    <?php echo "<td><a href='showJob.php?SociNo=".$row['SociNo']."'>".$row['SociNo']."</a></td>"; ?>
                </tr>
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>类别</b></font></td>
                    <?php echo "<td>".$row['Kind']."</td>"; ?>
                </tr>
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>级别</b></font></td>
                    <?php echo "<td>".$row['Level']."</td>"; ?>
                </tr>
                <!-- tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>上课时间</b></font></td>
                    <?php echo "<td>".$row['SchoolTime']."</td>"; ?>
                </tr> -->
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>社长姓名</b></font></td>
                    <?php echo "<td>".$row['ManaName']."</td>"; ?>
                </tr>
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>需求人数</b></font></td>
                    <?php echo "<td>".$row['LimitNum']."</td>"; ?>
                </tr>
                <tr>
                    <td width="100" bgcolor="#0066CC" align='right'><font color="#FFFFFF"><b>所属院系</b></font></td>
                    <?php echo "<td>".$row['DepartName']."</td>"; ?>
                </tr>
            </table>
        </td>
    </tr>
</table>
<center>
<?php
//
include ("maxorder.php");

//session_start();
//$stuno='17010001';
if ($_SESSION["role"] == "student")
{
    $stuno=$_SESSION["username"];
    $maxorder=getmaxorder($stuno);
    echo "<a href='takesoci.php?socino=$No&maxorder=$maxorder'>".$maxorder."选社团</a>";

}


echo "<br><a href='#' onclick='javascript:window.history.go(-1);return false'>返回列表</a><br>";
?>


</center>
</body>
</html>
